//add fcounty for Kansas
// fips codes accessed here: https://www.nrcs.usda.gov/wps/portal/nrcs/detail/national/home/?cid=nrcs143_013697
gen fcounty=.
replace fcounty=1 if county=="ALLEN" & state=="Kansas"
replace fcounty=3 if county=="ANDERSON" & state=="Kansas"
replace fcounty=5 if county=="ATCHISON" & state=="Kansas"
replace fcounty=7 if county=="BARBER" & state=="Kansas"
replace fcounty=9 if county=="BARTON" & state=="Kansas"
replace fcounty=11 if county=="BOURBON" & state=="Kansas"
replace fcounty=13 if county=="BROWN" & state=="Kansas"
replace fcounty=15 if county=="BUTLER" & state=="Kansas"
replace fcounty=17 if county=="CHASE" & state=="Kansas"
replace fcounty=19 if county=="CHAUTAUQUA" & state=="Kansas"
replace fcounty=21 if county=="CHEROKEE" & state=="Kansas"
replace fcounty=23 if county=="CHEYENNE" & state=="Kansas"
replace fcounty=25 if county=="CLARK" & state=="Kansas"
replace fcounty=27 if county=="CLAY" & state=="Kansas"
replace fcounty=29 if county=="CLOUD" & state=="Kansas"
replace fcounty=31 if county=="COFFEY" & state=="Kansas"
replace fcounty=33 if county=="COMANCHE" & state=="Kansas"
replace fcounty=35 if county=="COWLEY" & state=="Kansas"
replace fcounty=37 if county=="CRAWFORD" & state=="Kansas"
replace fcounty=39 if county=="DECATUR" & state=="Kansas"
replace fcounty=41 if county=="DICKINSON" & state=="Kansas"
replace fcounty=43 if county=="DONIPHAN" & state=="Kansas"
replace fcounty=45 if county=="DOUGLAS" & state=="Kansas"
replace fcounty=47 if county=="EDWARDS" & state=="Kansas"
replace fcounty=49 if county=="ELK" & state=="Kansas"
replace fcounty=51 if county=="ELLIS" & state=="Kansas"
replace fcounty=53 if county=="ELLSWORTH" & state=="Kansas"
replace fcounty=55 if county=="FINNEY" & state=="Kansas"
replace fcounty=57 if county=="FORD" & state=="Kansas"
replace fcounty=59 if county=="FRANKLIN" & state=="Kansas"
replace fcounty=61 if county=="GEARY" & state=="Kansas"
replace fcounty=63 if county=="GOVE" & state=="Kansas"
replace fcounty=65 if county=="GRAHAM" & state=="Kansas"
replace fcounty=67 if county=="GRANT" & state=="Kansas"
replace fcounty=69 if county=="GRAY" & state=="Kansas"
replace fcounty=71 if county=="GREELEY" & state=="Kansas"
replace fcounty=73 if county=="GREENWOOD" & state=="Kansas"
replace fcounty=75 if county=="HAMILTON" & state=="Kansas"
replace fcounty=77 if county=="HARPER" & state=="Kansas"
replace fcounty=79 if county=="HARVEY" & state=="Kansas"
replace fcounty=81 if county=="HASKELL" & state=="Kansas"
replace fcounty=83 if county=="HODGEMAN" & state=="Kansas"
replace fcounty=85 if county=="JACKSON" & state=="Kansas"
replace fcounty=87 if county=="JEFFERSON" & state=="Kansas"
replace fcounty=89 if county=="JEWELL" & state=="Kansas"
replace fcounty=91 if county=="JOHNSON" & state=="Kansas"
replace fcounty=93 if county=="KEARNY" & state=="Kansas"
replace fcounty=95 if county=="KINGMAN" & state=="Kansas"
replace fcounty=97 if county=="KIOWA" & state=="Kansas"
replace fcounty=99 if county=="LABETTE" & state=="Kansas"
replace fcounty=101 if county=="LANE" & state=="Kansas"
replace fcounty=103 if county=="LEAVENWORTH" & state=="Kansas"
replace fcounty=105 if county=="LINCOLN" & state=="Kansas"
replace fcounty=107 if county=="LINN" & state=="Kansas"
replace fcounty=109 if county=="LOGAN" & state=="Kansas"
replace fcounty=111 if county=="LYON" & state=="Kansas"
replace fcounty=113 if county=="MCPHERSON" & state=="Kansas"
replace fcounty=115 if county=="MARION" & state=="Kansas"
replace fcounty=117 if county=="MARSHALL" & state=="Kansas"
replace fcounty=119 if county=="MEADE" & state=="Kansas"
replace fcounty=121 if county=="MIAMI" & state=="Kansas"
replace fcounty=123 if county=="MITCHELL" & state=="Kansas"
replace fcounty=125 if county=="MONTGOMERY" & state=="Kansas"
replace fcounty=127 if county=="MORRIS" & state=="Kansas"
replace fcounty=129 if county=="MORTON" & state=="Kansas"
replace fcounty=131 if county=="NEMAHA" & state=="Kansas"
replace fcounty=133 if county=="NEOSHO" & state=="Kansas"
replace fcounty=135 if county=="NESS" & state=="Kansas"
replace fcounty=137 if county=="NORTON" & state=="Kansas"
replace fcounty=139 if county=="OSAGE" & state=="Kansas"
replace fcounty=141 if county=="OSBORNE" & state=="Kansas"
replace fcounty=143 if county=="OTTAWA" & state=="Kansas"
replace fcounty=145 if county=="PAWNEE" & state=="Kansas"
replace fcounty=147 if county=="PHILLIPS" & state=="Kansas"
replace fcounty=149 if county=="POTTAWATOMIE" & state=="Kansas"
replace fcounty=151 if county=="PRATT" & state=="Kansas"
replace fcounty=153 if county=="RAWLINS" & state=="Kansas"
replace fcounty=155 if county=="RENO" & state=="Kansas"
replace fcounty=157 if county=="REPUBLIC" & state=="Kansas"
replace fcounty=159 if county=="RICE" & state=="Kansas"
replace fcounty=161 if county=="RILEY" & state=="Kansas"
replace fcounty=163 if county=="ROOKS" & state=="Kansas"
replace fcounty=165 if county=="RUSH" & state=="Kansas"
replace fcounty=167 if county=="RUSSELL" & state=="Kansas"
replace fcounty=169 if county=="SALINE" & state=="Kansas"
replace fcounty=171 if county=="SCOTT" & state=="Kansas"
replace fcounty=173 if county=="SEDGWICK" & state=="Kansas"
replace fcounty=175 if county=="SEWARD" & state=="Kansas"
replace fcounty=177 if county=="SHAWNEE" & state=="Kansas"
replace fcounty=179 if county=="SHERIDAN" & state=="Kansas"
replace fcounty=181 if county=="SHERMAN" & state=="Kansas"
replace fcounty=183 if county=="SMITH" & state=="Kansas"
replace fcounty=185 if county=="STAFFORD" & state=="Kansas"
replace fcounty=187 if county=="STANTON" & state=="Kansas"
replace fcounty=189 if county=="STEVENS" & state=="Kansas"
replace fcounty=191 if county=="SUMNER" & state=="Kansas"
replace fcounty=193 if county=="THOMAS" & state=="Kansas"
replace fcounty=195 if county=="TREGO" & state=="Kansas"
replace fcounty=197 if county=="WABAUNSEE" & state=="Kansas"
replace fcounty=199 if county=="WALLACE" & state=="Kansas"
replace fcounty=201 if county=="WASHINGTON" & state=="Kansas"
replace fcounty=203 if county=="WICHITA" & state=="Kansas"
replace fcounty=205 if county=="WILSON" & state=="Kansas"
replace fcounty=207 if county=="WOODSON" & state=="Kansas"
replace fcounty=209 if county=="WYANDOTTE" & state=="Kansas"


